Purchasing Receipt Line Quantities (POP10500)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Receipt Line Quantities (POP10500)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POP10500

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Receipt Line Quantities
Physical Name: POP10500
Technical Name: POP_PORcptApply

Group Display Name: Purchasing Transactions
Group Technical Name: Purchasing Transactions

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PONUMBER	PO Number	String	STR17_POP_Number	17
2	POLNENUM	PO Line Number	Long Integer	LI_Sequence_Number	10
3	POPRCTNM	POP Receipt Number	String	STR17_POP_Number	17
4	RCPTLNNM	Receipt Line Number	Long Integer	LI_Sequence_Number	10
5	QTYSHPPD	QTY Shipped	Currency	DLR17_QTY_RBS0_UTR	17
6	QTYINVCD	QTY Invoiced	Currency	DLR17_QTY_RBS0_UTR	17
7	QTYREJ	QTY Rejected	Currency	DLR17_QTY_RBS0_UTR	17
8	QTYMATCH	QTY Matched	Currency	DLR17_QTY_RBS0_UTR	17
9	QTYRESERVED	QTY Reserved	Currency	DLR17_QTY_RBS0_UTR	17
10	QTYINVRESERVE	QTY Invoice Reserve	Currency	DLR17_QTY_RBS0_UTR	17
11	Status	Status	Integer	INT	0
12	UMQTYINB	U Of M QTY In Base	Currency	DLR17_QTY_RBS0_STR	17
	The quantity of the base unit of measure that is equivalent to one of the units of measure being referenced.
13	OLDCUCST	Old Current Cost	Currency	DLR17_RBS0_UTR$	17
14	JOBNUMBR	Job Number	String	STR17_LBAU	17
15	COSTCODE	Cost Code	String	STR27	27
16	COSTTYPE	Cost Code Type	Integer	INT3_RB0_U	3
17	ORCPTCOST	Originating Receipt Cost	Currency	DLR17_RBS0_UTR$	17
18	OSTDCOST	Originating Standard Cost	Currency	DLR17_RBS0_UTR$	17
19	APPYTYPE	Apply Type	Integer	INT	0
20	POPTYPE	POP Type	Integer	DDL_POP_Type	0
21	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].VENDORID AS 'Purchasing Receipt Line Quantities-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Purchasing Receipt Line Quantities'].VENDORID = ['PM Vendor Master File'].VENDORID
22	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].ITEMNMBR AS 'Purchasing Receipt Line Quantities-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN IV00101 AS ['Item Master'] ON ['Purchasing Receipt Line Quantities'].ITEMNMBR = ['Item Master'].ITEMNMBR
23	UOFM	U Of M	String	U_Of_M	8
	The unit of measure. The value in this field must exist in Inventory.
24	TRXLOCTN	TRX Location	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].TRXLOCTN AS 'Purchasing Receipt Line Quantities-TRX Location' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Purchasing Receipt Line Quantities'].TRXLOCTN = ['Site Setup'].LOCNCODE
25	DATERECD	Date Received	Date	DATE	6
26	RCTSEQNM	Receipt SEQ Number	Long Integer	long	8
27	SPRCTSEQ	Split Receipt SEQ Number	Long Integer	long	8
28	PCHRPTCT	Purchase Receipt Cost	Currency	DLR17_RBSO_UTR$	17
29	SPRCPTCT	Split Receipt Cost	Currency	DLR17_RBS0_UTR$	17
30	OREXTCST	Originating Extended Cost	Currency	DLR17_RBS0_UTR$	17
31	RUPPVAMT	Remaining UPPV Amount	Currency	DLR17_RBS0_UTR$	17
32	ACPURIDX	Accrued Purchases Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].ACPURIDX AS 'Purchasing Receipt Line Quantities-Accrued Purchases Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Purchasing Receipt Line Quantities'].ACPURIDX = ['Account Index Master'].ACTINDX
33	INVINDX	Inventory Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].INVINDX AS 'Purchasing Receipt Line Quantities-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Purchasing Receipt Line Quantities'].INVINDX = ['Account Index Master'].ACTINDX
34	UPPVIDX	Unrealized Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].UPPVIDX AS 'Purchasing Receipt Line Quantities-Unrealized Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Purchasing Receipt Line Quantities'].UPPVIDX = ['Account Index Master'].ACTINDX
35	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].NOTEINDX AS 'Purchasing Receipt Line Quantities-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Purchasing Receipt Line Quantities'].NOTEINDX = ['Record Notes Master'].NOTEINDX
36	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].CURNCYID AS 'Purchasing Receipt Line Quantities-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Receipt Line Quantities'].CURNCYID = ['Currency Setup'].CURNCYID
37	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].CURRNIDX AS 'Purchasing Receipt Line Quantities-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Receipt Line Quantities'].CURRNIDX = ['Currency Setup'].CURRNIDX
38	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
39	RATECALC	Rate Calc Method	Integer	INT	0
	Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank. Click to show/hide Rate Calc Methods 0 Multiply 1 Divide
40	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
41	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].RATETPID AS 'Purchasing Receipt Line Quantities-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['Purchasing Receipt Line Quantities'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
42	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['Purchasing Receipt Line Quantities'].EXGTBLID AS 'Purchasing Receipt Line Quantities-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM POP10500 AS ['Purchasing Receipt Line Quantities'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['Purchasing Receipt Line Quantities'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
43	Capital_Item	Capital Item	Boolean	CB_Capital_Item	0
44	Product_Indicator	Product Indicator	Integer	DDL_Product_Indicator	0
45	Total_Landed_Cost_Amount	Total Landed Cost Amount	Currency	DLR17_RBS0_UTR$	17
46	QTYTYPE	QTY Type	Integer	DDL_QTY_Type	0
47	Posted_LC_PPV_Amount	Posted LC PPV Amount	Currency	DLR17_RBS0_UTR$	17
48	QTYREPLACED	QTY Replaced	Currency	DLR17_QTY_RBS0_UTR	17
49	QTYINVADJ	QTY Invoice Adjustment	Currency	DLR17_QTY_RBS0_UTR	17

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Receipt Line Quantities (POP10500)

Leave a Reply Cancel reply